export const AnnouncementQueries = {
    GetAnnouncements: `
    SELECT
      id,
      announcementName,
      announcementType,
      announcementContent,
      announcementAttachmentPath,
      announcementAttachmentName,
      announcementDate,
      announcementCreatorId,
      announcementCreatorName,
      announcementStatus
    FROM my_schema.announcement
    `,
  
    GetAnnouncementById: `
    SELECT
      id,
      announcementName,
      announcementType,
      announcementContent,
      announcementAttachmentPath,
      announcementAttachmentName,
      announcementDate,
      announcementCreatorId,
      announcementCreatorName,
      announcementStatus
    FROM my_schema.announcement
    WHERE
      id = ?
    `,
  
    AddAnnouncement: `
    INSERT INTO my_schema.announcement (announcementName, announcementType, announcementContent, announcementAttachmentPath, announcementAttachmentName, announcementDate, announcementCreatorId, announcementCreatorName, announcementStatus, createdTime, updatedTime)
      VALUES ?
    `,

    UpdateAnnouncementById: `
    UPDATE my_schema.announcement
    SET ?
    WHERE
      id = ?
    `,
  
    DeleteAnnouncementById: `
    DELETE FROM my_schema.announcement
    WHERE
      id = ?
    `
  };